<%@ Control Language="VB" AutoEventWireup="false" codefile="FixtureList.ascx.vb" Inherits="FixtureList" %>
Fixture:
<asp:DropDownList ID="DropDownList1" Runat="server" DataSourceID="SqlDataSource1"
    DataTextField="Fixture" DataValueField="FixtureID" AutoPostBack="True">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
    SelectCommand="SELECT FixtureID, (Opponents + ' - ' + CONVERT(varchar, FixtureDate, 6)) As Fixture FROM dbo.Fixtures ORDER BY FixtureDate"
    ConnectionString="<%$ ConnectionStrings:WroxUnited %>">
</asp:SqlDataSource>
